package com.smartwebx.ha.dal.assign.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface HaRainWaterStatGrpMapper {

	@Select("SELECT c.station_id FROM "
			+ "ha_stationgroup_cfg a,ha_station_stationgroup b,ha_station_area c "
			+ "WHERE a.id = b.station_group_id AND b.stat_id = c.id AND a.code = #{statGroupCode}")
	List<String> getRainWaterStationByStatGroupId(
			@Param("statGroupCode") String statGroupCode);
}